Build a Full Stack IPL Cricket Analytics Dashboard & Statistics Platform | Capstone Project

Full Stack IPL Cricket Analytics Dashboard & Statistics Platform is an advanced capstone. You take 17 years of Indian Premier League ball-by-ball data (2008–2025) and turn it into a full cricket analytics platform that works like a real product.

You start with raw Cricsheet JSON match files. You build an automated Python pipeline that loads them into a 22-table PostgreSQL database. On top of that you build a FastAPI backend with 50+ REST endpoints, and a Next.js frontend with 14 interactive dashboard pages. The finished platform includes player and team stats, match scorecards, leaderboards, points tables with net run rate (NRR) calculated from the actual innings data, a head-to-head comparison tool, and secure login with JWT.

By the end you’ll have a portfolio project that covers data engineering, backend APIs, database design and frontend charts, built the way production sports analytics products are.

By the end of this capstone, you will be able to:

• Build a data ingestion pipeline that reads nested Cricsheet JSON files and loads them into a normalized database automatically, without loading the same file twice.
• Design a relational database with 22+ normalized tables, foreign keys, indexes and audit trails, and manage schema changes with SQLAlchemy and Alembic.
• Calculate cricket statistics from ball-by-ball data: batting average and strike rate, bowling economy, fielding stats, and per-season and career totals.
• Implement real cricket logic, including points tables and NRR calculated from innings data, plus season squads.
• Build 50+ REST API endpoints with FastAPI, with filtering, sorting, pagination and input validation.
• Add user authentication with JWT: sign-up, login, protected routes and token handling.
• Build a Next.js App Router frontend styled with Tailwind CSS, with 14 dashboard pages for teams, players, matches and seasons.
• Visualize data with Recharts and Chart.js: trend lines, comparison charts, leaderboards and scorecards.
• Build a head-to-head comparison tool for players and teams.
• Connect the frontend, backend and database into one working application, following clean architecture and code structure.